Stored Procedures [dbo].[asi_InsertChangeLog]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@logKeyuniqueidentifier16
@orgKeyuniqueidentifier16
@objectTypeNamenvarchar(100)200
@objectKeyuniqueidentifier16
@actionTypetinyint1
@descnvarchar(250)500
@createdOndatetime8
@createdByUserKeyuniqueidentifier16
SQL Script
CREATE PROCEDURE [dbo].[asi_InsertChangeLog]

@logKey uniqueidentifier,
@orgKey uniqueidentifier,
@objectTypeName nvarchar(100),
@objectKey uniqueidentifier,
@actionType tinyint,
@desc nvarchar(250),
@createdOn datetime,
@createdByUserKey uniqueidentifier

AS

INSERT
    ChangeLog (ChangeLogKey, OrganizationKey, ObjectTypeName, ObjectKey, ActionType, Description, CreatedOn, CreatedByUserKey)
    VALUES
    (@logKey, @orgKey, @objectTypeName, @objectKey, @actionType, @desc, @createdOn, @createdByUserKey)

GO
Uses